how to truncate all table in mysql workbench

SELECT
    Concat('TRUNCATE TABLE ', TABLE_NAME)
FROM
    INFORMATION_SCHEMA.TABLES
WHERE
    table_schema = 'db_name';

SELECT Concat('TRUNCATE TABLE ',table_schema,'.',TABLE_NAME, ';') 
FROM INFORMATION_SCHEMA.TABLES where  table_schema in ('db1_name','db2_name');

Submit

mysql format date	mysql grant all privileges to a user	finding duplicate column values in table with sql
mysql format date	order by sql	mysql show all tables
get all table name in sql through php	mysql show tables in database	select count of distinct values sql
import database through command line	sql server substring	rename table sql
selecting name that contain certain word in sql	install sqlite3 python	select duplicates in sql
ERROR 2002 (HY000): Cant connect to local MySQL server through socket -tmp-mysql.sock (2)	alter table add foreign key mysql	mysql delete row
how to auto increment in sql	how to install mysql ubuntu	sql where contains
how to create a table structure from another table in mysql	select nextval from sequence sql	truncate table
install sqlite npm	postgresql check total storage	GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
how to select one row in mysql	select row from mysql where date more than 30 days	sql view where tables have same column name combine results
python mysql check if database exists	drop table if exists	mysql month name extract
SQL SERVER Add Identity Column to existing table	update using case in mysql	No module named MySQLdb
sql count duplicate rows	how to install postgresql on wsl	group_concat limit mysql
sort by sql	query to list all tables in sql database	SELECT User,Host FROM mysql.user;
create a view in sqlite	mysql get last insert id	SQL UPDATE Statement
mysql show table column full description	postgressql uuid	t sql get foreign key